Prerequisites
Before you begin to work with an IBM Informix database as a source in Qlik Replicate, make sure that the following prerequisites have been met:
-
Qlik Replicate machine:
- Qlik Replicate installed in your network.
- IBM Informix ODBC Driver (64-bit) version 3.70 or later must be installed on the computer where Qlik Replicate is located.
- The
DB_LOCALE=<Informix_db_locale_value>
environment variable must be set to be the name of the IBM Informix database locale from which you want to capture data. - The
INFORMIXSQLHOSTS
environment variable must be set to include the names of the IBM Informix servers that are available for use as Replicate source endpoints.
-
IBM Informix Server:
- An IBM Informix account with the required Required permissions.
-
CDC enabled. To enable CDC, run the script
$INFORMIXDIR/etc/syscdcv1.sql
on the IBM Informix server.Information noteThis requires DBA privileges (User 'IBM Informix' or another DBA user).
- Make sure that the database to be replicated was created with either the
WITH LOG
or theWITH BUFFERED LOG
property.